package com.example.qxfw.nyqx.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.ny.Diseaseindexlib;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
@DS("service")
public interface DiseaseindexlibMapper extends BaseMapper<Diseaseindexlib> {
    @Select("select cropname, growdate , diseasesname,id " +
            "from diseaseindexlib " +
            "where (starttime<='${startTime}' and endtime>='${startTime}')or (starttime<='${endTime}' and endtime>='${endTime}')or(starttime>='${startTime}' and endtime<='${endTime}') or (starttime<='${startTime}' and endtime>='${endTime}') ")
    List<Diseaseindexlib> selectList(String startTime, String endTime);
}
